package eteam.aps.systemservice.dal.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import eteam.aps.systeminterface.model.entity.CustomerEntity;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface ICustomerMapper extends BaseMapper<CustomerEntity> {
    @Select("select max(FCode) from sp_customer where locate('${prefix}',FCode)>0")
    String selectMaxCustCode(@Param("prefix") String prefix);
}
